﻿<html DIR="LTR" xmlns:tool="http://www.microsoft.com/tooltip" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:ddue="http://ddue.schemas.microsoft.com/authoring/2003/5" xmlns:MSHelp="http://msdn.microsoft.com/mshelp">
  <head>
    <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=utf-8" />
    <META NAME="save" CONTENT="history" />
    <title>Readme_Analysis Services Personalization Extensions Sample</title>
    
    
    
    <style TYPE="text/css">
body
{
background: #FFFFFF;
color: #000000;
font-family:    Verdana;
font-size: medium;
font-style: normal;
font-weight: normal;
margin-top: 0;
margin-bottom:  0;
margin-left:    0;
margin-right:   0;
width:  100%;
}

div.#mainSection
{
font-size: 70%;
width: 100%;
padding-left:    10;
margin-right: 10;
}

div.#mainBody
{
font-size: 90%;
margin-top: 10;
padding-bottom: 20;
}

div.#header
{
background-color: #D2D2D2;
padding-top:    0;
padding-bottom: 0;
padding-left:   10;
padding-right:  0;
width:          100%;
}

div.#header table
{
border-bottom-color: #C8CDDE;
border-bottom-style: solid;
border-bottom-width: 1;
width:  100%;
}

span.#runningHeaderText
{
color: #003399;
font-size: 90%;
}

span.#nsrTitle
{
/*    color: #003399;*/
font-size: 120%;
font-weight: 600;
}

div.#header table td
{
color: #000000;
font-size: 70%;
margin-top: 0;
margin-bottom:  0;
padding-right: 20;
}

div.#header table tr.#headerTableRow3 td
{
padding-bottom: 2;
padding-top: 5;
}

div.#header table.#bottomTable
{
border-top-color: #FFFFFF;
border-top-style: solid;
border-top-width: 1;
text-align: left;
}

div.#footer
{
font-size: 90%;
margin-top: 0;
margin-bottom:  0;
margin-left:    -5;
margin-right:   0;
padding-top:    2;
padding-bottom: 2;
padding-left:   0;
padding-right:  0;
width:  100%;
}

hr.#footerHR
{
border-bottom-color: #EEEEFF;
border-bottom-style: solid;
border-bottom-width: 1;
border-top-color: C8CDDE;
border-top-style: solid;
border-top-width: 1;
height: 3;
color: #D2D2D2;
}

div.section
{
padding-top:    2;
padding-bottom: 2;
padding-right:  15;
width:  100%;
}

.heading
{
color:          #000000;
font-weight:    bold;
margin-top:     18;
margin-bottom:  8;
}

h1.heading
{
color: #000000;
font-size:  150%;
}

.subHeading
{
color:          #000000;
font-weight:    bold;
font-size:      150%;
margin-bottom:  4;
}

h2.subHeading
{
color:          #000000;
font-weight:    bold;
font-size:      130%;
}
h3.subHeading
{
color:  #000000;
font-size: 125%;
font-weight: bold;
}

h4.subHeading
{
color: #000000;
font-size: 110%;
font-weight: bold;
}

h4.procedureHeading
{
color: #000080;
font-size: 110%;
font-weight: bold;
}

h5.subHeading
{
color: #000000;
font-size: 100%;
font-weight: bold;
}

img
{
padding-bottom: 10;
}

img.toggle
{
border: 0;
margin-right: 5;
padding-bottom: 10;
}

img.copyCodeImage
{
border: 0;
margin: 1;
margin-right: 3;
padding-bottom: 10;
}

img.downloadCodeImage
{
border: 0;
margin-right: 3;
padding-bottom: 10;
}

img.viewCodeImage
{
border: 0;
margin-right: 3;
padding-bottom: 10;
}

img.note
{
border: 0;
margin-right: 3;
padding-bottom: 10;
}

img.#membersOptionsFilterImage
{
border: 0;
margin-left: 10;
vertical-align: middle;
padding-bottom: 10;
}

img.#toggleAllImage
{
margin-left: 4;
vertical-align: middle;
padding-bottom: 10;
}

div.#mainSection table
{
border: 0;
font-size: 100%;
width:  100%;
margin-top: 5px;
margin-bottom: 15px;
}

div.#mainSection table tr
{
vertical-align: top;
}

div.#mainSection table th
{
text-align: left;
background: #D8D8D8;
border-bottom-color: #D8D8D8;
border-bottom-style: solid;
border-bottom-width: 1;
color: #000000;
padding-left: 5;
padding-right: 5;
}

div.#mainSection table td
{
background: #F2F2F2;
border-top-color: #D8D8D8;
border-top-style: solid;
border-top-width: 1;
padding-left: 5;
padding-right: 5;
}

div.#mainSection table td.imageCell
{
white-space: nowrap;
}

div.code
{
width: 98%;
}

div.code table
{
border: 0;
font-size: 95%;
margin-bottom: 5;
width: 100%
}

div.code table th
{
text-align: left;
background: #D8D8D8;
border-bottom-color: #D8D8D8;
border-bottom-style: solid;
border-bottom-width: 1;
color: #000000;
font-weight: bold;
padding-left: 5;
padding-right: 5;
}

div.code table td
{
background: #CCCCCC;
border-top-color: #D8D8D8;
border-top-style: solid;
border-top-width: 1;
padding-left: 5;
padding-right: 5;
padding-top: 5;
}

div.alert
{
margin-left: 10;
width: 98%;
}

div.alert table
{
border: 1;
font-size: 100%;
width:  100%;
border: solid 1 #DEDFEF;
}

div.alert table th
{
text-align: left;
background: #D8D8D8;
border-bottom-width: 0;
color: #000000;
padding-left: 5;
padding-right: 5;
border: solid 1 #DEDFEF;
}

div.alert table td
{
background: #FFFFFF;
border-top-color: #D8D8D8;
border-top-style: solid;
border-top-width: 1;
padding-left: 5;
padding-right: 5;
border: solid 1 #DEDFEF;
}

span.copyCode
{
color: #0000ff;
font-size: 90%;
font-weight: normal;
cursor: hand;
float: right;
display: inline;
text-align: right;
}

.downloadCode
{
color: #0000ff;
font-size: 90%;
font-weight: normal;
cursor: hand;
}

.viewCode
{
color: #0000ff;
font-size: 90%;
font-weight: normal;
cursor: hand;
}

div.code pre
{
font-family:    Monospace, Courier New, Courier;
font-size: 105%;
color:  #000000;
}

code
{
font-family:    Monospace, Courier New, Courier;
font-size: 105%;
color:  #000000;
}

dl
{
margin-top: 0;
padding-left:   1;
}

dd
{
margin-bottom:  0;
margin-left:    0;
padding-left:   20;
}

dd p
{
margin-top: 5;
}

ul
{
margin-left: 17;
list-style-type: disc;
}

ul ul
{
margin-bottom: 4;
margin-left: 17;
margin-top: 3;
list-style-type: disc;
}

ol
{
margin-left: 24;
list-style-type: decimal;
}

ol ol
{
margin-left: 24;
margin-top: 3;
list-style-type: lower-alpha;
}

li
{
margin-top: 0;
margin-bottom: 0;
padding-bottom: 0;
padding-top: 0;
margin-left: 5;
}

p
{
margin-bottom: 15;
}

.tip
{
color:  #0000FF;
font-style: italic;
cursor:hand;
text-decoration:underline;
}

.math
{
font-family: Times New Roman;
font-size: 125%
}
.sourceCodeList
{
font-family: Verdana;
font-size: 90%;
}

pre.viewCode
{
width: 100%;
overflow: auto;
}

li:hover table, li.over table
{
background-color: #C0C0C0;
}

li:hover ul, li.over ul
{
background-color: #d2d2d2;
border: 1px solid #000;
display: block;
}
            </style>
  </head>
  <body>
    <!--Topic built:02/12/2008 21:30:29-->

    
    
    
    
    
    
    
    
    
    <div id="header">
      <table width="100%" id="topTable"><tr>
          <td align="left">
            <span id="nsrTitle">Readme_Analysis Services Personalization Extensions Sample</span>
          </td>
          <td align="right">
            <span id="headfb" class="feedbackhead">
            </span>
          </td>
        </tr></table>
      
      
      
    </div>
    <div id="mainSection">
      <div id="mainBody"><p> 2/12/2008 9:30:29 PM</p>
        
        <font color="DarkGray">[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.] </font><p /> 
        <span id="changeHistory">
        </span>
    <p>This sample works only with SQL Server 2008. It will not work with any version of SQL Server earlier than SQL Server 2008.</p>
    <p>The Analysis Services Personalization Extensions sample is a C# program that illustrates how to create user-based personalizations. These personalizations are not permanent objects in the cube, but are objects that the client application applies dynamically during the user's session.</p>
    <p>The Analysis Services Personalization Extensions sample dynamically creates a different object for three different users. For each user connection, the sample enables only the object that is associated with that user. Each of these personalization objects is only visible during the user's session.</p>
  <h1 class="heading">Scenario</h1><div id="sectionSection0" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <p xmlns="">An independent software vendor (ISV) creates an interface that enables a user to design business metrics for his or her company, and then share those metrics with that user's peers. The metrics are dynamic and adjustable to the person who uses them. For example, the ISV designs a client interface that enables a company's business analyst to design a Sales Monthly Goal Tracking indicator. This indicator calculates and tracks the monthly sales goal for each salesperson. The business analyst can then share this indicator with the company's sales team. Now, any member on the team can easily know how he or she is doing towards the monthly goal, as the indicator is automatically  tailored to the goals of each salesperson. </p>
      <p xmlns="">Without the personalization extensions, the indicator would have to be passed to the company's Analysis Services team. This Analysis Services team would have to incorporate the indicator directly into the cube design and then redeploy the cube to the end users. Because the indicator would be an object in the cube, the indicator would not be personalized to each user.</p>
    </content></div><h1 class="heading">Languages</h1><div id="sectionSection1" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <p xmlns="">C#</p>
    </content></div><h1 class="heading">Features</h1><div id="sectionSection2" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <p xmlns="">The Analysis Services Personalization Extensions Sample uses the following features of SQL Server 2008 Analysis Services (SSAS).</p>
      <table width="100%" cellspacing="0" cellpadding="0" border="1" style="background-color: #CCCCCC;" xmlns=""><tr>
            <th>
              Application Area
            </th>
            <th>
              Features
            </th>
          </tr><tr>
          <td>
            <p>
              AdventureWorks
            </p>
          </td>
          <td>
            <p>ADOMD.NET Server, MDX</p>
          </td>
        </tr></table>
    </content></div><h1 class="heading">Prerequisites</h1><div id="sectionSection3" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <p xmlns="">Before you run this sample, you should have SQL Server and the following SQL Server components installed:</p>
      <ul xmlns=""><li>
          
            SQL Server Database Engine
          <br />
        </li><li>
          
            Analysis Services
          <br />
        </li><li>
          
            SQL Server Management Studio
          <br />
        </li><li>
          
            Business Intelligence Development Studio
          <br />
          <div class="alert"><table width="100%" cellspacing="0" cellpadding="0"><tr><th align="left">Note: </th></tr><tr><td>
             Business Intelligence Development Studio is not supported on Itanium-based computers. The 64-bit development environment is supported on x64-based operating systems. SQL Server 2005 samples can be modified and run on computers that run either x86 or x64-based operating systems when databases used by the samples are deployed on an Itanium-based computer.<p />
          </td></tr></table><p /></div>
        </li><li>
          Updated versions of the following SQL Server sample databases: the AdventureWorks data warehouse and the AdventureWorks database.<br />
          You can download these sample databases from the <a href="http://go.microsoft.com/fwlink/?LinkId=85384" alt=""><linkText xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">Microsoft SQL Server Samples and Community Projects</linkText></a> Web site. For more information about how to download and install sample databases, see <a href="html/e8117979-fe03-441e-be85-894fa616227a.htm">Installing SQL Server Samples and Sample Databases</a>.<br />
        </li><li>
          Updated versions of the following SQL Server samples: Analysis Services samples and SQL Server Database Engine samples.<br />
          You can download these samples from the <a href="http://go.microsoft.com/fwlink/?LinkId=85384" alt=""><linkText xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">Microsoft SQL Server Samples and Community Projects</linkText></a> Web site. For more information about how to download and install samples, see <a href="html/e8117979-fe03-441e-be85-894fa616227a.htm">Installing SQL Server Samples and Sample Databases</a>.<br />
        </li></ul>
      <p xmlns="">You also need .NET Framework SDK 2.0 or Microsoft Visual Studio 2005 installed. You can obtain .NET Framework SDK free of charge. For more information, see <b>Installing the .NET Framework SDK</b></p>
    </content></div><h1 class="heading">Building the Sample</h1><div id="sectionSection4" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <p xmlns="">The Analysis Services Personalization Extensions Sample is composed of one binary file, ASPE.dll.</p>
      <p xmlns="">
        	
	<p>If you have not already created a strong name key file, generate the key file using the following instructions.</p>
	<h4 class="procedureHeading">
	
	To generate a strong name key file
	</h4>
	<div id="procedureSectionEDBDBHA" class="section">
	<ol>
	<li>Open a Microsoft Visual Studio 2005 command prompt. Click <b>Start</b>, point to <b>All Programs</b>, point to <b>Microsoft .NET Framework SDK 2.0</b>, and then click <b>SDK Command Prompt</b>.<p>-- or --</p>
	<p>Open a Microsoft .NET Framework command prompt. Click <b>Start</b>, point to <b>All Programs</b>, point to <b>Microsoft .NET Framework SDK 2.0</b>, and then click <b>SDK Command Prompt</b>.</p>
	</li>
	<li>Use the change directory command (CD) to change the current directory of the command prompt window to the folder where the samples are installed.<div class="alert">
	<table width="100%" cellspacing="0" cellpadding="0">
	<tr>
	<th align="left">
	Note:</th>
	</tr>
	<tr>
	<td>To determine the folder where samples are located, click the <b>Start</b> button, point to <b>All Programs</b>, point to <b>Microsoft SQL Server</b>, point to <b>Documentation and Tutorials</b>, and then click <b>Samples Directory</b>. If the default installation location was used, the samples are located in &lt;system_drive&gt;:\Program Files\Microsoft SQL Server\100\Samples.
	</td>
	</tr>
	</table>
	</div>
	</li>
	<li>At the command prompt, run the following command to generate the key file:<p>
	<code>sn -k SampleKey.snk</code>
	</p>
	<div class="alert">
	<table width="100%" cellspacing="0" cellpadding="0">
	<tr>
	<th align="left">
	Important:</th>
	</tr>
	<tr>
	<td>For more information about the strong-name key pair, see "Security Briefs: Strong Names and Security in the .NET Framework" in the .NET Development Center on MSDN.</td>
	</tr>
	</table>
	</div>
	</li>
	</ol>
	</div>

      </p>
      <h4 class="procedureHeading" xmlns="">To build the Analysis Services Personalization Extensions Sample</h4><div id="procedureSectionEBBNBHA" class="section" xmlns=""><ol><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Rename SampleKey.snk to ASPE.snk and move the file to the same location where ASPE.sln is.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Compile ASPE.dll by using: </p>
              <ul xmlns=""><li>
                  
                    Visual Studio 2005 and the ASPE.sln file.<br />
                </li></ul>
              <p xmlns="">— or —</p>
              <ul xmlns=""><li>
                  
                    Microsoft MSBuild, which is included in the .NET Framework SDK 2.0. Change directory to the location where the solution file ASPE.sln is located. Run a command similar to the following at a command prompt:<br />
                </li></ul>
              <p xmlns="">
                <code>msbuild /nologo /verbosity:quiet /property:Configuration=Debug ASPE.sln</code>
              </p>
            </content>
          </li></ol>
          <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
            <p xmlns="">You can use other MSBuild build options depending on your needs.</p>
          </content>
        </div>
    </content></div><h1 class="heading">Deploying the Sample</h1><div id="sectionSection5" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <p xmlns="">To deploy the Analysis Services Personalization Extensions sample, you must add the assembly that you built in the previous procedure to a running instance of Analysis Services.</p>
      <h4 class="procedureHeading" xmlns="">To add ASPE.dll assembly to a running instance of Analysis Services</h4><div id="procedureSectionEBBLBHA" class="section" xmlns=""><ol><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">In SQL Server Management Studio, connect to the instance of Analysis Services.</p>
              <p xmlns="">
                <i>Localhost</i> is assumed as the default instance for this sample. Replace <i>localhost</i> in with the name of the instance that you have selected.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">At the server level, open the <b>Assemblies</b> folder and verify that the ASPE assembly is not listed.</p>
              <p xmlns="">If the ASPE assembly is listed, remove this assembly by right-clicking the assembly and selecting <b>Delete.</b> Continue following the steps on the screen.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Right-click <b>Assemblies</b> and select <b>New Assembly</b>.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">In the <b>Register Server Assembly</b> dialog box, select the following options:</p>
              <ol xmlns=""><li>
                  For <b>Type</b>, select <b>.NET Assembly</b>.<br />
                </li><li>
                  For <b>Filename</b>, click the browse button <b>[…]</b> and find the ASPE.dll file in your project folder under <b>bin/debug</b> folders.<br />
                </li><li>
                  For <b>Permissions</b>, select <b>Unrestricted</b>.<br />
                </li><li>
                  For <b>Impersonation</b>, select <b>Use the Service Account</b>.<br />
                </li><li>
                  
                    Click <b>OK</b>.
                  <br />
                </li></ol>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">At the server level, open the <b>Assemblies</b> folder and verify the ASPE assembly is listed.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">To enable the correct management of all events, open SQL Server Configuration Manager, select <b>SQL Server Services</b>, and then select the <b>SQL Server Analysis Services</b> row. Click the restart button to restart the service </p>
            </content>
          </li></ol></div>
    </content></div><h1 class="heading">Preparing the Environment to Test the Sample</h1><div id="sectionSection6" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <p xmlns="">On the same server where you are running Analysis Services and have deployed ASPE.dll, use the following procedures to set up the environment to test the sample.</p>
      <h4 class="procedureHeading" xmlns="">To add three users to your current system</h4><div id="procedureSectionEFBJBHA" class="section" xmlns=""><ol><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Click <b>Start</b>, right-click <b>My Computer</b>, and select <b>Manage</b>.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Expand <b>Local Users and Groups</b> to see the <b>Users</b> and <b>Groups</b> folders.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Right-click the <b>Users</b> folder and select <b>New User</b>.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">In the <b>New User</b> dialog box, select the following options:</p>
              <ol xmlns=""><li>
                  For <b>User name</b>, type <b>user1</b>.<br />
                </li><li>
                  For <b>Password</b>, type a strong password that meets your company standards.<br />
                </li><li>
                  For <b>Confirm password</b>, re-type your selected password.<br />
                </li><li>
                  Clear the <b>User must change password at next logon</b> check box.<br />
                </li><li>
                  Select the <b>Password never expires</b> check box.<br />
                </li></ol>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Repeat step 4 for <b>user2</b> and <b>user3</b>.</p>
            </content>
          </li></ol></div>
      <h4 class="procedureHeading" xmlns="">To verify Adventure Works DW database is deployed and contains Adventure Works cube</h4><div id="procedureSectionEDBJBHA" class="section" xmlns=""><ol><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">On an Analysis Services instance, open SQL Server Management Studio and connect to the <b>Server name</b>, <i>localhost</i>.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Expand the <b>Databases</b> node and verify that the <b>Adventure Works DW</b> database exists.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Expand the <b>Adventure Works DW</b> node, expand the <b>Cubes</b> node, and verify that the <b>Adventure Works</b> cube exists.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Right-click the <b>Adventure Works</b> cube and select <b>Properties</b>. Verify that the cube <b>State</b> is <b>Processed</b>. </p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">If any one of the previous steps cannot be completed, see the Books Online topic, <a href="http://go.microsoft.com/fwlink/?LinkId=83253" alt=""><linkText xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">Running Setup to Install AdventureWorks Sample Databases and Samples</linkText></a>, in the MSDN Library.</p>
            </content>
          </li></ol></div>
      <h4 class="procedureHeading" xmlns="">To add a role for the new users and give them access to the cube and dimensions</h4><div id="procedureSectionEBBJBHA" class="section" xmlns=""><ol><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">On an Analysis Services instance, open SQL Server Management Studio and connect to the <b>Server Name</b>, <i>localhost</i>. </p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Expand the <b>Databases</b> node, and then expand the <b>Adventure Works DW</b> database.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Right-click <b>Roles</b>, and then select <b>New role</b>.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">In the <b>Create Role</b> dialog box, click the <b>General</b> page, and select the following options:</p>
              <ol xmlns=""><li>
                  For <b>Role name</b>, type <b>ASPE Test Users</b>.<br />
                </li><li>
                  Select the <b>Read definition</b> check box.<br />
                </li><li>
                  Clear the <b>Full control (Administrator)</b> and <b>Process database</b> check boxes.<br />
                </li></ol>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Click the <b>Membership</b> page, and select the following options:</p>
              <ol xmlns=""><li>
                  Click <b>Add</b>.<br />
                </li><li>
                  In the <b>Select Users or Groups</b> window, for <b>Enter the object names to select</b>, type <b>user1; user2; user3</b>.<br />
                </li><li>
                  Click <b>Check Names</b>.<br />
                  The values should now appear underlined, with the server or domain name in front of each name.<br />
                </li><li>
                  
                    Click <b>OK</b>.
                  <br />
                </li></ol>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Click the <b>Data Sources</b> page. In the <b>Access</b> column for the <b>Adventure Works DW</b> row, select <b>Read</b>.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Click the <b>Cubes</b> page, and select the following options for the <b>Adventure Works</b> row:</p>
              <ol xmlns=""><li>
                  In the <b>Access</b> column, select <b>Read</b>.<br />
                </li><li>
                  In the <b>Local Cube/Drillthrough Access</b> column, select <b>Drillthrough and Local Cube</b>. Click <b>OK</b> to accept the message.<br />
                </li><li>
                  In the <b>Process</b> column, select the check box.<br />
                </li></ol>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Click the <b>Dimensions</b> page. For each of the rows in <b>Dimensions</b>, select the <b>Process</b> column check box.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Click <b>OK</b>, and then wait until the command is processed and the new role is created.</p>
            </content>
          </li></ol></div>
    </content></div><h1 class="heading">Testing the Sample</h1><div id="sectionSection7" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <p xmlns="">Testing the sample demonstrates that new personalization objects are created in different user contexts and that those objects are associated with the user profile.</p>
      <h4 class="procedureHeading" xmlns="">To verify your context</h4><div id="procedureSectionEHBHBHA" class="section" xmlns=""><ol><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">In SQL Server Management Studio, connect to the <b>Server Name</b>, <i>localhost</i>.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">On the Standard toolbar, click <b>Analysis Services MDX Query</b>. </p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Connect to the <b>Server Name</b>, <i>localhost</i>.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">On the SQL Server Analysis Services toolbar, select the <notLocalizable xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5"><b xmlns="">Adventure Works DW</b></notLocalizable> database if it is not already selected.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">In the left pane of the MDX tab, in the <b>Cube</b> list, select the <notLocalizable xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5"><b xmlns="">Adventure Works</b></notLocalizable> cube if it is not already selected.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Select the <b>Metadata</b> tab if it is not already selected.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Expand the <b>Measures</b> node. </p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Expand the <b>Internet Sales</b> node, and verify that there is no <b>ISV_1</b> folder under this node. </p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Expand the <b>Geography</b> dimension, and verify that there is no <b>ISV_1</b> folder in this dimension.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Expand the <b>Product</b> dimension, and verify that there is no <b>ISV_1</b> folder in this dimension.</p>
            </content>
          </li></ol></div>
      <h4 class="procedureHeading" xmlns="">To verify the context for user1</h4><div id="procedureSectionEFBHBHA" class="section" xmlns=""><ol><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Users running Windows XP or Windows Server 2003. Right-click the SQL Server Management Studio icon, select <b>Run as</b>, and then select the following options:</p>
              <ol xmlns=""><li>
                  Select <b>The following user</b>.<br />
                </li><li>
                  Replace with <b>user1</b>. Make sure that the domain or server name is correct.<br />
                </li><li>
                  Proceed to step 3.<br />
                </li></ol>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Users running Windows Vista or Windows Server 2008. Open a command window and run the following command:<code>runas.exe /profile /user:</code><i>&lt;Domain&gt;</i><code>\user1 "</code><i>&lt;Path-to-ssms&gt;</i><code>\Ssms.exe"</code></p>
              <ol xmlns=""><li>
                  Replace <i>&lt;Domain&gt;</i> with the correct domain or server name.<br />
                </li><li>
                  Replace <i>&lt;Path-to-ssms&gt;</i> with the complete path to ssms.exe, the executable file for SQL Server Management Studio.<br />
                  <div class="alert"><table width="100%" cellspacing="0" cellpadding="0"><tr><th align="left">Note: </th></tr><tr><td>
                    Windows Vista and Windows Server 2008 no longer have the <b>Run as</b> option when you right-click an application.<p />
                  </td></tr></table><p /></div>
                </li></ol>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Ensure that <b>Server type</b> is set to Analysis Services, then connect to the <b>Server name</b>, <i>localhost</i>.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">On the Standard toolbar, click <b>Analysis Services MDX Query</b>. </p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Connect to the <b>Server name</b>, <i>localhost</i>.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">On the SQL Server Analysis Services toolbar, select <b>Adventure Works DW</b> database, if it is not already selected.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">In the left pane of the MDX tab, in the <b>Cube</b> list, select the <b>Adventure Works</b> cube, if it is not already selected.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Select the <b>Metadata</b> tab, if it is not already selected.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Expand the <b>Measures</b> node, and then expand the <b>Internet Sales</b> node to see the <b>ISV_1</b> folder.</p>
              <p xmlns="">Unlike your user context, user1 has an <b>ISV_1 </b>folder under the <b>Internet Sales</b> node.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Expand the <b>ISV_1</b> folder, expand the <b>Common</b> folder. Noticethe <b>Gross Internet Profit</b> member is visible to this user.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Return to the <b>Measures</b> node and expand the <b>Reseller Sales</b> measure group, expand the <b>ISV_1</b> folder, and then expand the <b>Operations</b> folder.</p>
              <p xmlns="">Notice that the <b>Operations</b> folder contains the <b>Average Item Freight Cost</b> member.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Expand the <b>Geography</b> dimension, expand the <b>ISV_1</b> folder, and then expand the <b>Common</b> folder to see the <b>ISV_1 - Western Coast</b> set.</p>
              <p xmlns="">Unlike your user context, user1 does have access to the <b>ISV_1 - Western Coast</b> set.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Expand the <b>Product</b> dimension, expand the <b>ISV_1</b> folder, and then expand the <b>Operations</b> folder to see the <b>Touring Bikes</b> set.</p>
              <p xmlns="">Unlike your user context, user1 has access to the <b>Touring Bikes</b> set.</p>
            </content>
          </li></ol></div>
      <h4 class="procedureHeading" xmlns="">To verify the context for user2</h4><div id="procedureSectionEDBHBHA" class="section" xmlns=""><ol><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Users running Windows XP or Windows Server 2003. Right-click the SQL Server Management Studio icon, select <b>Run as</b>, and then select the following options:</p>
              <ol xmlns=""><li>
                  Select <b>The following user</b>.<br />
                </li><li>
                  Replace with <b>user2</b>. Make sure that the domain or server name is correct.<br />
                </li><li>
                  Proceed to step 3.<br />
                </li></ol>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Users running Windows Vista or Windows Server 2008. Open a command window and run the following command:<code>runas.exe /profile /user:</code><i>&lt;Domain&gt;</i><code>\user2 "</code><i>&lt;Path-to-ssms&gt;</i><code>\Ssms.exe"</code></p>
              <ol xmlns=""><li>
                  Replace <i>&lt;Domain&gt;</i> with the correct domain or server name.<br />
                </li><li>
                  Replace <i>&lt;Path-to-ssms&gt;</i> with the complete path to ssms.exe, the executable file for SQL Server Management Studio.<br />
                  <div class="alert"><table width="100%" cellspacing="0" cellpadding="0"><tr><th align="left">Note: </th></tr><tr><td>
                    Windows Vista and Windows Server 2008 no longer have the <b>Run as</b> option when you right-click an application.<p />
                  </td></tr></table><p /></div>
                </li></ol>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Ensure that <b>Server type</b> is set to Analysis Services, then connect to the <b>Server name</b>, <i>localhost</i>.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">On the Standard toolbar, click <b>Analysis Services MDX Query</b>. </p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Connect to the <b>Server name</b>, <i>localhost</i>.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">On the Analysis Services toolbar, select the <b>Adventure Works DW</b> database if it is not already selected.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">In the left pane of the MDX tab, in the <b>Cube</b> list, select the <b>Adventure Works</b> cube if it is not already selected.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Select the <b>Metadata</b> tab if it is not already selected.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Expand the <b>Measures</b> node, expand the <b>Internet Sales</b> node, expand the <b>ISV_1</b> folder, and expand the <b>Common</b> folder. Notice the the <b>Gross Internet Profit</b> member is also visible to this user. </p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Return to the <b>Measures</b> node and expand the <b>Reseller Sales</b> measure group, and verify that there is no <b>ISV_1</b> folder in this group.</p>
              <p xmlns="">Only user1 has an <b>ISV_1</b> folder in the <b>Reseller Sales</b> measure group.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Return to the <b>Measures</b> node and expand the <b>Exchange Rates</b> measure group, expand the <b>ISV_1</b> folder, and then expand the <b>Finance</b> folder to see the <b>Rate Difference </b>member.</p>
              <p xmlns="">Notice that for user2 only, the <b>Exchange Rates</b> measure group has an <b>ISV_1</b> folder.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Expand the <b>Geography</b> dimension, expand the <b>ISV_1</b> folder, and then expand the <b>Common</b> folder to see the <b>ISV_1 - Western Coast</b> set.</p>
              <p xmlns="">Notice that user2, just like user1, has access to the <b>ISV_1 - Western Coast</b> set.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Expand the <b>Product</b> dimension, expand the <b>ISV_1</b> folder, and then expand the <b>Finance</b> folder to see the <b>Mountain Bikes</b> set.</p>
              <p xmlns="">While user2 has access to the <b>Mountain Bikes</b> set, user2 does not have access to the <b>Touring Bikes</b> set in the <b>Operations</b> folder. Only user1 has access to the <b>Touring Bikes</b> set<b>.</b></p>
            </content>
          </li></ol></div>
      <h4 class="procedureHeading" xmlns="">To verify the context for user3</h4><div id="procedureSectionEBBHBHA" class="section" xmlns=""><ol><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Users running Windows XP or Windows Server 2003. Right-click the SQL Server Management Studio icon, select <b>Run as</b>, and then select the following options:</p>
              <ol xmlns=""><li>
                  Select <b>The following user</b>.<br />
                </li><li>
                  Replace with <b>user3</b>. Make sure that the domain or server name is correct.<br />
                </li><li>
                  Proceed to step 3.<br />
                </li></ol>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Users running Windows Vista or Windows Server 2008. Open a command window and run the following command:<code>runas.exe /profile /user:</code><i>&lt;Domain&gt;</i><code>\user3 "</code><i>&lt;Path-to-ssms&gt;</i><code>\Ssms.exe"</code></p>
              <ol xmlns=""><li>
                  Replace <i>&lt;Domain&gt;</i> with the correct domain or server name.<br />
                </li><li>
                  Replace <i>&lt;Path-to-ssms&gt;</i> with the complete path to ssms.exe, the executable file for SQL Server Management Studio.<br />
                  <div class="alert"><table width="100%" cellspacing="0" cellpadding="0"><tr><th align="left">Note: </th></tr><tr><td>
                    Windows Vista and Windows Server 2008 no longer have the <b>Run as</b> option when you right-click an application.<p />
                  </td></tr></table><p /></div>
                </li></ol>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Ensure that <b>Server type</b> is set to Analysis Services, then connect to the <b>Server name</b>, <i>localhost</i>.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">On the Standard toolbar, click <b>Analysis Services MDX Query</b>. </p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Connect to the <b>Server name</b>, <i>localhost</i>.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">On the Analysis Services toolbar, select <b>Adventure Works DW</b> database, if it is not already selected.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">In the left pane of the MDX tab, in the <b>Cube</b> list, select the <b>Adventure Works</b> cube, if is not already selected.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Select the <b>Metadata</b> tab, if it is not already selected.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Expand the <b>Measures</b> node, expand the <b>Internet Sales</b> node, expand the <b>ISV_1</b> folder, and expand the <b>Common</b> folder. Notice that the <b>Gross Internet Profit</b> member is visible to this user.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Return to the <b>Measures</b> node and expand the <b>Reseller Sales</b> measure group, and verify that there is no <b>ISV_1</b> folder in this group.</p>
              <p xmlns="">Only user1 has an <b>ISV_1</b> folder in the <b>Reseller Sales</b> measure group.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Return to the <b>Measures</b> node and expand the <b>Exchange Rates</b> measure group, and verify that there is no <b>ISV_1</b> folder in this group.</p>
              <p xmlns="">Only user2 has an <b>ISV_1</b> folder in the <b>Exchange Rates</b> measure group.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Return to the <b>Measures</b> node and expand the <b>Reseller Orders</b> measure group, expand the <b>ISV_1</b> folder, and then expand the <b>Marketing</b> folder to see the <b>Reseller Discount per Order</b> member.</p>
              <p xmlns="">Notice that for user3 only, the <b>Reseller Orders</b> measure group has an <b>ISV_1</b> folder.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Expand the <b>Geography</b> dimension, expand the <b>ISV_1</b> folder, and expand the <b>Common</b> folder to see <b>ISV_1 - Western Coast</b> set.</p>
              <p xmlns="">user3, just like user1 and user2, has access to the <b>ISV_1 - Western Coast</b> set.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Expand the <b>Product</b> dimension, expand the <b>ISV_1</b> folder, and then expand the <b>Marketing</b> folder to see the <b>All Terrain Bikes</b> set.</p>
              <p xmlns="">While user3 has access to the <b>All Terrain Bikes</b> set, user3 does not have access to the <b>Touring Bikes</b> set in the <b>Operation</b> folder. Only user1 has access to the <b>Touring Bikes</b> set. User3 also has access to the <b>Mountain Bikes</b> set in the <b>Finance</b> folder. It is user2 who has no access to the <b>All Terrain Bikes</b> set.</p>
            </content>
          </li></ol></div>
    </content></div><h1 class="heading">Troubleshooting the Sample</h1><div id="sectionSection8" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <p xmlns="">Use the following set of procedures to troubleshoot the Analysis Services Personalization Extensions sample.</p>
      <h4 class="procedureHeading" xmlns="">To define debug breakpoints in the code</h4><div id="procedureSectionEFBFBHA" class="section" xmlns=""><ol><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">In Visual Studio 2005, open ASPE.sln.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Open the source code for the <i>ASClientExtensions.cs</i> source file, and then set a breakpoint on the opening brace of the <i>ASClientExtensions</i> constructor.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Open the source code for the <i>SessionMgr.cs</i> source file, and then set the following breakpoints:</p>
              <ol xmlns=""><li>
                  Set a breakpoint on the opening brace of the <i>SessionMgr</i> constructor.<br />
                </li><li>
                  Set a breakpoint on the opening brace of the <i>CubeOpened</i> method.<br />
                </li></ol>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Open the source code for the <i>AuthoringAndManagement.cs</i> source file, and then set the following breakpoints.</p>
              <ol xmlns=""><li>
                  Set a breakpoint on the opening brace of the <i>AuthoringAndManagement</i> constructor.<br />
                </li><li>
                  Set a breakpoint on the opening brace of the <i>DefineMembers</i> method.<br />
                </li><li>
                  Set a breakpoint on the opening brace of the <i>DefineSets</i> method.<br />
                </li><li>
                  Set a breakpoint on the opening brace of the <i>DefineKPIs</i> method.<br />
                </li></ol>
            </content>
          </li></ol></div>
      <h4 class="procedureHeading" xmlns="">To attach to the running instance of Analysis Services</h4><div id="procedureSectionEDBFBHA" class="section" xmlns=""><ol><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">In the menu bar, select <b>Debug</b>, and then select <b>Attach to process</b>.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">In the <b>Available Processes</b> pane, browse to find <b>msmdsrv.exe</b>, and then select it.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Click <b>Attach</b>, and then wait until the debugger attaches to the running process.</p>
            </content>
          </li></ol></div>
      <h4 class="procedureHeading" xmlns="">To run through the breakpoints</h4><div id="procedureSectionEBBFBHA" class="section" xmlns=""><ol><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Repeat all the steps in the procedure, <b>To verify the context for user1</b>.</p>
              <p xmlns="">Notice that SQL Server Management Studio does not immediately appear. Instead, Visual Studio opens.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">To see the sequence of events, press F11 repeatedly.</p>
              <p xmlns="">If there are no more events, check SQL Server Management Studio to continue with the steps in the procedure, <b>To verify the context for user1</b>.</p>
            </content>
          </li></ol></div>
    </content></div><h1 class="heading">Removing the Sample</h1><div id="sectionSection9" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <p xmlns="">Use the following procedure to remove the Analysis Services Personalization Extensions Sample.</p>
      <h4 class="procedureHeading" xmlns="">To remove the roles and assembly from the current Analysis Services instance</h4><div id="procedureSectionEFBDBHA" class="section" xmlns=""><ol><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Open SQL Server Management Studio. </p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Connect to the <b>Server Name</b>, <i>localhost</i> </p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Expand the <b>Databases</b> node, and then expand <b>Adventure Works DW</b> database.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Expand <b>Roles</b>, right-click <b>ASPE Test Users</b>, select <b>Delete</b>, and then click <b>OK</b>.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">At server level, expand <b>Assemblies</b>, right-click <b>ASPE</b>, select <b>Delete</b>, and then click <b>OK</b>.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Close SQL Server Management Studio.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Restart the service</p>
            </content>
          </li></ol></div>
      <h4 class="procedureHeading" xmlns="">To remove the user created for this sample</h4><div id="procedureSectionEDBDBHA" class="section" xmlns=""><ol><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Click <b>Start</b>, right-click <b>My Computer</b>, and select <b>Manage</b>.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Expand <b>Local Users and Groups</b> to see the <b>Users</b> and <b>Groups</b> folders.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Expand the <b>Users</b> folder.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Remove user1, user2, user3 by right-clicking each user, selecting <b>Delete</b>, and then clicking <b>OK</b>.</p>
            </content>
          </li></ol></div>
      <h4 class="procedureHeading" xmlns="">To remove the ASPE sample</h4><div id="procedureSectionEBBDBHA" class="section" xmlns=""><ul><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">From your solution folder, in the ASPE folder, remove the <b>bin</b> and <b>obj</b> folders.</p>
            </content>
          </li></ul></div>
    </content></div><!--[if gte IE 5]>
			<tool:tip element="seeAlsoToolTip" avoidmouse="false"/><tool:tip element="languageFilterToolTip" avoidmouse="false"/><tool:tip element="roleInfoSpan" avoidmouse="false"/>
		<![endif]--></div>
      <div id="footer">
			
			© 2008 Microsoft Corporation. All rights reserved.
		</div>
    </div>
  </body>
</html>